SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50319 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50319 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (638413,918860,789585,725712,382458,68819,703636,521748,965571,997456,599856,207629,933613,670409,338216,652035,1001423,316200,72432,564804,519208,254602,39823,318976,301447,110604,414544,12015,703233,125676,822368,238386,593878,741777,556034,489014,295288,225437,84928,53461,636532,363190,25300,557341,125076,195260,703765,118656,119321,524056,540593,366091,591981,438690,116738,672727,249701,591075,650213,526063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]