SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002881s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412341 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412341 [ RunTime:0.003774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231258,898222,305279,420432,173785,580919,437437,807095,392413,754361,546815,631884,870829,371525,463187,381585,563968,186766,956764,150234,693963,273862,346210,343604,35059,476138,944255,483453,461201,124734,505437,488217,126775,255912,448812,365585,991438,311269,223278,348476,530988,99825,398246,712534,52203,546701,276792,324665,443371,369964,409022,828180,252846,755607,820801,613459,752333,512537,533549,38769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000845s ]