SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018016 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018016 [ RunTime:0.002818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289469,263511,194958,143536,261384,997212,1001064,116415,281971,504581,602614,799946,1046699,362736,262131,974253,661702,685688,532494,825284,260565,950581,830366,116562,749369,110441,93894,580171,427997,211813,287019,501769,823184,897959,766704,601285,54846,503096,582125,911551,867014,111796,721175,637598,1006017,931322,425800,17406,674754,510605,805739,889936,985251,394015,560532,937720,963610,326931,853541,1037994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000380s ]