SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004443s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012880 LIMIT 1 [ RunTime:0.000618s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012880 [ RunTime:0.003492s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166369,809785,27443,423188,127709,384421,737869,632443,1016898,858195,106752,711137,502485,360024,623818,590322,272405,310488,129386,414139,855127,255993,649643,617448,954669,261727,408408,625817,855817,448982,868876,210300,535074,180506,706841,590296,378147,381443,186438,894515,609827,196360,23314,573938,476105,316711,529081,464451,515843,860998,171781,338056,547473,134039,433875,973888,91678,941094,70740,577032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]