SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31945 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31945 [ RunTime:0.001842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (375128,573119,959573,487391,838853,268917,382345,336031,591840,1010719,1030118,688380,878990,197468,314011,585221,61636,160328,453341,644228,731925,769339,151403,1014575,586990,492923,914244,381006,771287,233850,830474,654952,524041,976568,30436,543918,221890,310391,243759,515601,702255,928657,984961,1013414,994654,952112,380416,447638,919755,402771,369858,1021142,93446,631724,161288,791418,26658,81732,1025279,103489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31945 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31945 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]