SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 720383 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 720383 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (742356,15523,640386,125323,871959,200509,136409,177525,53168,38528,199736,584508,113927,540768,832164,996586,17580,421848,481814,236278,717738,406416,304800,1040146,883250,700533,843297,527674,571770,157378,967240,488522,539414,756746,741944,608137,974090,671345,910610,292772,445384,623305,542057,365490,642747,304950,732003,384316,692237,662329,1007865,876294,427059,419083,355493,446122,294279,799708,946718,656123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 720383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 720383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]