SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046498 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046498 [ RunTime:0.002472s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182901,611744,452693,280840,171212,711177,283089,847142,680288,410368,598453,349266,687131,821866,252092,419842,135467,497167,908214,652631,296375,865297,329684,376890,1041382,435162,757685,683104,718972,613337,321410,1012861,547667,26170,724424,47557,555811,717844,990177,638168,391069,68548,32342,766305,423457,570695,349872,217809,688432,871120,244546,290762,314643,418000,416121,334285,274480,69098,448946,591515) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001792s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]