SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510153 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510153 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623013,974481,108125,60976,501702,309461,529435,628687,575848,528955,255801,730016,893462,804005,400874,472496,1032326,148710,665740,272833,952671,448397,7672,970602,808883,50336,1046008,898750,498157,126419,583110,394131,806270,634552,250452,707478,191341,535701,340245,91761,679185,793181,190155,405494,520124,748913,370655,733687,666556,345837,755937,290525,544816,818075,872870,36990,288833,911758,241121,279623) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510153 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510153 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]