SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580250 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580250 [ RunTime:0.001510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414466,313812,635359,909935,552177,289194,1019286,180985,538674,631646,640830,681282,479872,84399,48128,566870,39634,695593,534314,257090,788683,594000,768365,510091,731928,140103,496693,1001781,955265,1015641,896859,396897,65676,866605,373203,152786,433520,1034634,1018695,112549,1045481,312309,809729,1027846,671008,280490,751166,263941,299757,928471,139207,12340,1041637,124347,187420,980187,654643,946925,1018453,929712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580250 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580250 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000896s ]