SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334443 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334443 [ RunTime:0.002238s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011642,875841,658418,998641,607326,169450,295559,226033,765356,361931,578303,943644,964022,773029,799426,231188,748475,334280,2872,702233,42184,119526,691994,792469,879647,591893,935509,637077,499696,959758,818834,960290,722558,188725,965442,389691,136315,522149,779560,934666,525374,772717,105346,741090,488697,582532,209208,697802,169879,156076,84590,1038396,649735,425697,20817,471871,803098,15122,1010548,39615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]