SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 222369 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 222369 [ RunTime:0.002780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846442,981566,110173,801366,291089,289838,564085,538419,1045064,18117,371717,955243,155410,277103,538712,140822,1430,110598,851347,648516,945634,73508,314443,1020271,921418,138540,310093,475751,542557,731487,883619,831997,872024,984764,256418,145364,926996,626428,560525,565061,781447,21677,815529,505935,959154,975347,826687,378260,792917,726093,767201,536309,374833,933093,7488,759327,663340,750641,622656,450036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 222369 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 222369 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000392s ]