SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102918 LIMIT 1 [ RunTime:0.003931s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102918 [ RunTime:0.004123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (669206,881,620752,999778,622067,365043,760656,69528,91069,135704,922697,927768,236164,250895,1034107,252489,266611,576242,623062,590694,674662,542809,183976,524767,911723,580678,1007927,573759,61062,450026,564333,131604,755389,649075,526360,691367,638583,645160,977930,77826,267193,682264,743955,798413,921573,843059,687920,655117,37277,672192,478319,1010681,299637,377369,212905,943147,857178,177028,992608,32249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003740s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000806s ]