SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548943 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548943 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920910,203631,716797,35288,773782,608927,1030728,567188,975818,584501,193298,606561,856936,586800,85641,366126,337946,746916,938347,332190,633097,423422,345105,523477,54062,436215,718248,219088,690083,1040128,424165,290087,936316,608078,393790,914748,120418,743190,859558,379632,948333,895711,678723,51517,421221,983880,1016027,817881,553321,455298,69418,550305,526809,595649,807101,914415,853893,758532,70252,238924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001715s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]