SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417369 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417369 [ RunTime:0.002065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587028,605931,891632,144754,192199,754355,661584,922763,834835,758439,942835,247032,503941,261390,916905,6339,36238,651353,434488,165402,394616,461205,401781,476506,540481,366235,560446,196243,766261,1019422,807133,720874,550894,82977,992125,110136,689241,974042,258140,747876,612895,381137,178296,557473,40076,203173,644191,237806,967780,805677,953771,236399,268844,1015035,1004557,949614,301150,849837,570297,1018296) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417369 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417369 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]