SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043013 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043013 [ RunTime:0.003109s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433829,368647,16054,110723,822392,845980,845640,958402,378001,91188,654028,324362,68881,655846,152480,549537,426095,676966,90315,221826,263279,126163,825564,590730,836454,88377,706719,418391,1000328,304779,33043,691271,624256,683892,145883,370254,717381,188411,883130,929029,478848,537319,696213,917845,808720,922546,835373,888181,838608,651204,843504,22411,109845,209263,935796,235391,275687,537539,72993,1044418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]