SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802754 LIMIT 1 [ RunTime:0.001394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802754 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871194,863634,621218,242463,744260,258385,29696,371689,414699,91841,587769,132812,279152,574831,1002410,878989,609166,683589,935443,978005,651954,583996,1045808,169596,290051,188097,872782,120683,527560,347029,767475,284629,142544,45359,988212,1011436,654589,28690,657175,454848,866896,239381,634603,534695,805685,125968,622929,436966,664999,460157,276245,464956,671197,372321,23647,807763,361233,585264,223509,13623) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802754 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802754 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]