SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39560 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39560 [ RunTime:0.001999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118797,217794,531777,205126,609632,65423,918740,392382,478956,856118,719046,155637,87106,510844,890078,159606,208154,830741,895221,875228,1005809,498867,9715,186616,481594,134331,983361,1046099,360644,101148,664706,327586,434867,114517,853496,1037665,524444,301839,411082,954306,1046316,856462,1007322,520033,1005762,48764,464189,1048047,23142,904560,458811,147124,831752,620324,898963,372663,866892,417406,226149,611395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]