SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804883 LIMIT 1 [ RunTime:0.003059s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804883 [ RunTime:0.002849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930831,608830,382010,487470,417792,844713,717199,265785,7255,740383,1046539,1037303,365133,14625,955441,48090,353048,317447,264270,144829,1002135,346124,1013416,531457,775775,346081,625324,439394,945339,961209,332494,999112,246746,702738,393934,574211,499327,693912,400904,958088,960285,434947,337682,314580,948348,251242,21461,976019,322492,634127,180282,739934,417844,779312,14146,683434,662175,698466,257632,429650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]