SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461104 LIMIT 1 [ RunTime:0.000513s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461104 [ RunTime:0.001944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197888,1034527,349585,376962,813948,371641,814438,854326,510705,697209,1035411,649255,282380,521548,649283,325122,713173,54652,104206,307376,1003402,1014609,25235,104454,702608,1044500,558035,399407,632415,591165,291750,970364,769990,939971,851058,824796,467743,955205,477554,33159,963868,729114,377535,405518,15009,296372,199620,319681,42113,322286,1045037,531433,435555,1039778,1026124,942444,440281,242539,403915,218470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]