SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313575 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313575 [ RunTime:0.001508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (641032,849791,627151,766455,237811,699148,610378,141154,293961,26040,1027225,501968,1005706,128463,524453,620845,675192,227489,123618,426420,978016,321602,779004,735585,913617,625256,683019,343626,275873,1043554,950159,812924,733668,851844,733579,644287,847826,150763,85258,164880,616747,1040382,160698,938277,677266,388182,381202,743451,858898,209989,482790,424217,448117,845895,97590,1010050,387599,851250,16197,79774) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]