SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417838 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417838 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525223,145786,61626,419350,477122,745358,544909,543714,471445,279608,977506,876113,756532,735580,906180,768968,394285,625423,705530,883338,86478,284592,742870,895316,805834,905822,683238,62149,803090,715156,357136,1022987,313872,876977,394542,410615,891897,104601,62821,821139,407248,143552,811163,903672,1014954,756250,707432,895596,712638,388877,477377,111976,170518,255812,394961,867786,231727,66978,296147,440862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]