SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017808 LIMIT 1 [ RunTime:0.001971s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017808 [ RunTime:0.001901s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467222,695800,12774,78143,33814,1037357,1048058,1679,829173,607152,92363,620644,551222,134074,129625,109751,407897,726075,46789,702335,550648,859439,821674,352147,828898,941951,708516,767390,906247,438638,615796,659591,608083,497634,580599,266927,598854,982755,226299,283395,590601,890340,166484,837886,924438,525123,811656,1034011,857870,369664,224381,499552,798985,368868,1012626,1005692,813764,195978,445672,141295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]