SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408056 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408056 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351508,668302,365789,1026143,517961,345272,441706,475849,335248,805827,184826,918297,718245,124714,282214,734514,975706,578437,230853,424582,1012813,481839,900637,627766,397204,655503,494214,924221,963832,273679,118627,974,284863,944492,871471,498847,692652,701432,818601,433524,393339,631884,795537,126581,549806,762510,469554,798817,568540,234271,665038,410865,221986,164185,720430,76438,355493,1018502,53948,187223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]