SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397417 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397417 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (872444,387782,611541,1029039,229270,497703,275634,635009,73535,770075,462233,186727,804606,995388,1028476,876961,575203,666755,216424,407131,107237,515954,725523,829345,98975,331473,474292,567325,773282,554629,58269,1026427,157316,201152,48497,458673,517285,48612,536197,745587,415174,539035,321105,69918,670405,124671,799494,980521,628276,338138,178963,123987,353215,882060,939379,902960,707673,129740,8460,515443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]