SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440843 LIMIT 1 [ RunTime:0.000645s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440843 [ RunTime:0.002656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803295,879944,140268,379064,475973,675477,927656,665993,198045,175909,434526,625051,189749,1002021,17491,129146,212282,159681,883680,559637,338471,555927,845771,823920,181612,952966,158200,284760,137380,36850,771,745979,115089,879594,993568,968832,401971,373195,524876,644396,895187,295474,410337,122969,176791,73421,436764,800078,29055,725808,351469,759737,120700,39570,966291,263667,872806,1009444,175809,100549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000921s ]