SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002070s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110281 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110281 [ RunTime:0.002342s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (271211,511049,820768,15766,956775,587608,204212,873449,939644,500689,257518,726660,966450,80042,414962,305264,765286,433142,320113,63906,706147,780739,379866,604153,961754,70265,874507,31954,1008088,709366,1033586,841243,990183,718705,779082,658095,501383,739770,777497,797221,822878,76841,77872,743499,774415,806981,761936,187613,322394,953934,451713,65873,602847,330147,1026365,55462,796355,641425,337771,815412) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001887s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]