SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481204 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481204 [ RunTime:0.001647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846546,62485,248140,474602,921619,850405,964896,175818,601893,210385,437018,894303,941422,681077,983707,263939,679202,1031851,467318,663248,10647,749679,363973,797153,591224,150300,640505,331858,1034877,92419,677449,438962,914884,432719,724958,735006,982820,1000133,939359,786978,189983,919644,280282,157797,169501,792412,238821,899720,867517,734033,209584,80745,234149,1044727,620303,606742,588251,206908,387990,689633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]