SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407464 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407464 [ RunTime:0.004006s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958080,549785,466066,550834,451898,1026912,42236,201288,56341,434931,84626,260945,316856,248830,1040234,881778,324193,182216,504871,292366,805506,754619,1041852,604181,289493,337706,1035880,17765,59301,548423,372112,348716,515036,843404,150786,125967,282681,1030851,14223,445075,473925,392612,109631,440988,878977,716542,43157,190262,1004515,979554,156157,338575,669172,558516,574310,372256,409720,300035,1001305,660839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407464 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407464 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]