SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343811 LIMIT 1 [ RunTime:0.000781s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343811 [ RunTime:0.002976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123204,776037,1003665,842946,952770,965567,373852,596424,574489,996056,820362,345047,40656,982335,924994,78726,677030,793484,534332,795115,772859,849243,256959,287404,368081,732290,682318,558048,605808,145727,960008,243407,584153,1031786,170291,141110,191044,309939,733162,142884,1001975,64072,233923,519643,348437,440746,757035,904004,316570,375555,820207,213193,803274,341543,159869,212362,1029477,4051,1023717,592244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002720s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]