SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341473 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341473 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137541,165614,479617,619605,691610,756234,294430,1037129,197990,530992,597610,287644,604640,1009060,368499,449200,280701,366731,965141,537248,350304,237726,356060,508818,608274,505851,234006,871981,696703,358860,175930,447514,976714,243547,133876,315307,106592,895276,120490,283679,106035,599589,331045,177667,630571,424543,953489,176440,743028,791183,313583,846750,332457,186826,491432,98728,79030,245492,189198,387610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000785s ]