SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438073 LIMIT 1 [ RunTime:0.001054s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438073 [ RunTime:0.002072s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014419,422495,931790,327532,850703,453795,660271,400902,897310,906512,155294,3351,797397,72466,765213,510044,475141,751022,208905,388473,14842,585177,311334,457619,442379,431941,200734,565756,967265,519502,862175,691595,515837,956541,192485,436624,81301,528841,153534,795964,857542,149368,817250,26015,456060,527798,28947,466250,837366,443323,200261,760195,759847,291279,478810,944141,577717,1031264,562812,94332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002834s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]