SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382815 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382815 [ RunTime:0.002554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (370747,455177,402631,287302,769491,346729,187870,406554,111371,352561,421442,1015148,328998,347087,129515,211795,747204,388724,291537,134160,995916,356258,894311,1033565,694451,374235,855800,606510,220287,961217,180380,656205,64882,930431,570518,83259,9867,543614,544118,307604,283303,951737,655628,621576,271929,413716,213610,182847,213487,387547,467099,904165,930954,605730,45360,1030624,320881,621491,586678,95213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]