SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453310 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453310 [ RunTime:0.003447s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (173742,530457,142721,525245,647559,343898,155558,340333,857755,831513,563241,276176,863410,537643,16216,1029140,706714,980724,760206,72916,498030,185,839556,948408,91237,559115,850519,724136,39448,478029,967863,244402,8780,475634,150276,435642,213413,408334,93779,282442,953188,695894,768113,360829,251474,97301,596134,938822,966108,306238,715383,629033,153331,301212,971176,472402,952868,413701,390709,559994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002026s ]