SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504419 LIMIT 1 [ RunTime:0.000906s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504419 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (804824,702496,69939,856174,759069,787558,284112,283182,470909,2611,577391,106252,1023868,43383,901123,246622,190699,615827,62849,959073,675774,348924,627340,252533,501180,765239,20970,150532,206222,775065,833157,6021,1036688,401393,845896,840575,95503,46474,815173,426562,1034901,527374,690075,319398,78538,449654,429716,408792,900465,850637,590503,868267,1006357,606979,498487,575347,159847,964860,336643,384408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000748s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001265s ]