SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001578s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42110 LIMIT 1 [ RunTime:0.000561s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42110 [ RunTime:0.001846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710308,852881,179385,761055,727637,335114,27150,297240,849079,804978,959542,664128,462641,171365,889071,531873,441591,705340,885122,83760,149652,432174,975780,822307,709328,713780,845435,95983,1005524,126262,338905,478341,912485,460499,708764,788590,10979,976240,578178,515533,443546,465370,903479,548640,1033587,377897,593242,184789,906292,147179,851884,50428,89248,869532,427060,696719,863782,753454,538099,994341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000767s ]