SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578083 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578083 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491023,156585,903013,982137,974672,848759,1016976,1034270,536611,511505,282340,839166,33489,150873,358236,783650,121426,471550,958014,904959,381432,944942,4245,268974,810467,407754,842369,711804,989184,589810,632124,1012119,980834,286569,439220,155026,531159,322228,633175,996473,741565,648303,50590,890620,942527,879820,861,206831,1042391,385228,142456,678588,806960,289842,699167,426641,30733,949615,709239,483317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]