SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014830 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014830 [ RunTime:0.001471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691453,27007,676295,1004886,121119,610595,491119,378970,215091,16775,725615,508903,364739,534486,911637,33204,389356,995947,161070,925522,1030682,694162,170932,451794,241934,388690,1023279,200893,803012,362231,1018501,662222,599514,808798,897725,477550,1026156,711238,73741,901380,970030,1003084,83324,333687,163498,501500,790991,751401,211460,947646,966687,596198,9845,126817,445830,113356,545924,189014,491971,185685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]