SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108221 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108221 [ RunTime:0.003347s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499118,605924,186787,920410,777347,705333,701415,742093,43508,296319,645043,1000423,547225,550367,769909,767907,1027766,625120,775261,678127,318837,884500,99136,555435,179166,791905,999286,35297,452608,17920,200328,556528,714216,140355,353373,1034497,53394,261401,45047,713479,97605,443579,631946,411111,674138,599601,833718,289946,639270,985391,151384,475736,896795,117943,80959,976313,93977,121330,932018,453939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]