SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101224 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101224 [ RunTime:0.001464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439728,799369,585301,91515,950947,640882,153105,255851,325987,416818,784946,361279,1023974,930766,107978,806477,616707,454175,930258,961904,999604,248752,438816,972848,221694,259303,48166,905392,178831,138525,557824,495342,17272,676219,857499,961879,5311,712505,846823,822627,1505,304606,993318,819226,276764,20760,695551,768048,650764,968334,482277,620018,222238,452569,923470,956928,748428,31563,28592,747600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101224 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101224 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]