SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393912 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393912 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68158,174103,241666,514049,590529,84479,796646,138486,593174,1022238,242185,964753,657176,12891,473869,954517,64979,748308,83515,709234,803120,521007,123803,515215,366681,108580,980337,177446,256251,595498,805196,688853,272419,638675,845359,828406,208202,151815,278441,620474,938477,394002,324502,463826,974538,992689,946605,879954,576160,897817,351933,866172,558532,543784,182616,831122,459896,48061,86044,866721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]