SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 309296 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 309296 [ RunTime:0.002266s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403513,915333,161125,423589,395410,802362,963937,1004880,1003094,175630,772184,67473,394952,810390,900931,98423,664299,600108,691375,131831,472945,315003,1043707,185839,120942,499551,157192,747127,757433,580844,874942,798097,1047878,902288,361550,386871,776491,649519,215511,599036,897860,189151,468015,119788,206613,981689,467564,1025650,113393,186750,271663,1015777,890496,219877,362195,152439,880639,158495,150182,678908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 309296 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 309296 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]