SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29963 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29963 [ RunTime:0.002204s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813424,690789,901779,374307,1013425,1005839,281439,36194,450824,1036508,400173,284725,466440,904737,56884,1002515,941574,935966,113991,165720,413002,230476,1012866,250821,166101,37944,793609,549153,785358,981189,864385,543979,836745,751356,182597,21792,761387,111377,135920,679604,947067,529975,796115,65833,346545,1024133,590791,254897,885024,62081,886268,191649,686426,138764,377134,34149,805605,603650,901204,488587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001175s ]