SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001470 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001470 [ RunTime:0.002185s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182597,209494,420900,453727,405377,182059,856145,861733,509207,32947,173993,99084,499117,979864,127308,852314,787275,363290,107357,871294,516853,900446,757364,334274,30935,1002790,12423,115355,909266,690997,21697,456171,317534,874183,1031419,644856,555155,459876,1044223,310975,399960,823538,464538,146026,254021,731140,967081,480346,952909,139729,332222,200361,151908,927048,135540,916560,1008551,860903,253585,814427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001537s ]