SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520402 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520402 [ RunTime:0.002117s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002757,652401,156313,643241,1002271,884342,896038,382405,382887,615029,978801,987506,977096,905692,902376,175469,165224,808278,448636,943384,571341,783986,1022759,271424,1012211,849865,45086,965559,90161,660357,74018,26594,424723,943145,1017607,522171,597771,186009,969863,38208,826774,225818,811403,925823,981013,905715,200010,34467,179333,904469,453113,194656,604006,1002540,475341,618616,349031,1041778,551612,475229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520402 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520402 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]