SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341011 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341011 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122167,1011494,850385,579056,242411,960043,6151,183335,752681,534225,833495,647389,86793,434076,384436,929091,984289,884277,654788,640071,145470,64459,182692,612176,868802,359281,280143,792690,384201,180277,650487,607047,129000,683702,357156,893672,1021442,441251,392243,49803,823521,145880,521979,853180,161722,42488,970217,208962,170462,275258,203031,281035,300502,747297,162830,631054,219257,797041,869559,784721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]