SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 368905 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 368905 [ RunTime:0.002157s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29493,878120,418521,908303,146996,652486,415742,1039251,930916,521073,54879,9079,625072,174232,222140,262672,11503,899215,200615,664197,847004,184342,282171,239771,701180,923841,341169,387382,49075,578011,116246,270199,1034456,80838,191587,111779,432590,332832,694844,624692,584188,504289,182240,123473,754512,879411,825851,867077,192108,1007345,231229,111512,506089,731543,131494,1005731,793527,983271,28096,875419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 368905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 368905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]