SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417963 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417963 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259489,562312,688191,40185,4234,144407,219230,340687,658852,317086,360518,120090,648641,127193,656457,21395,392796,77106,622662,1001685,322396,979565,881343,660372,454172,63234,542878,898059,1020236,248029,1029366,436930,272582,670533,787897,202210,637091,579080,147414,866120,306380,1027612,748905,544996,325587,964594,821754,541694,729315,571361,982930,35280,846029,746991,1037468,964148,757219,890696,389531,155524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]