SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405012 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405012 [ RunTime:0.002962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159500,731257,678862,524390,546561,303313,515674,62637,610181,835495,560142,305775,474421,98464,296588,910318,413407,290188,437999,320516,3,344121,737006,537043,593905,165497,304841,516514,861102,779964,344176,298244,159991,350150,252925,388465,171039,305583,604540,250434,249046,90820,963333,535197,277075,762334,572095,916915,687933,360058,1030090,933364,668112,374455,38291,447644,50847,873973,1020087,632934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]