SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455587 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455587 [ RunTime:0.002005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (854924,1043777,399015,1040414,721520,230685,572917,901829,493511,909257,256150,240275,142135,929821,751854,322846,657631,128138,110874,634315,724565,837724,584301,883724,304066,421380,810918,961578,31772,484156,382729,48259,598522,236141,110254,537763,133555,458616,402817,301481,985699,342326,719463,655021,1005045,761166,67856,567506,87653,551570,285528,560709,277621,985380,921056,420213,348892,844623,703784,430030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455587 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455587 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]