SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413218 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413218 [ RunTime:0.002785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399552,595927,477902,209119,556018,398472,35323,275115,999146,239174,112636,120718,750044,374641,832716,142523,947928,208222,690830,991918,212746,772591,431178,501332,723908,194549,648858,688275,620033,216505,13815,545206,1027291,310530,914060,552538,718507,843168,867485,78269,888568,206467,475704,826694,898875,1043024,818782,1044365,172421,405592,863886,118062,1047445,324581,756537,188542,853228,675263,912413,808893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]