SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401246 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401246 [ RunTime:0.002650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31523,181573,498175,140623,463760,612216,219360,1622,695597,510659,414705,998066,678865,672820,334944,255566,72593,821350,182662,1006314,933142,259534,589327,284559,614181,764391,1035964,516046,41063,454618,30207,856857,1017029,676921,698211,255143,896775,736276,1004760,827408,572306,1027232,812675,480738,34098,781896,388820,505491,760292,1022237,111952,321430,841988,767508,759303,765787,666808,428395,65859,63936) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001089s ]