SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001833s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027961 LIMIT 1 [ RunTime:0.000652s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027961 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (225542,207407,892633,887436,773085,27026,983535,688359,405829,131679,763234,387496,10569,616705,58412,106740,728940,557292,203686,344517,1018790,326669,988190,258518,3615,465677,365265,115893,567688,894487,629507,936642,632174,499583,114176,976024,908905,436647,882242,620657,74556,194443,612260,683794,565255,162618,649455,324601,11325,123036,660434,428996,453789,371509,492988,217194,229795,402033,841303,14852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002661s ]