SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490810 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490810 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417762,531409,1047454,202201,419725,853785,959996,219720,884592,388945,855879,894301,480542,714828,911942,388322,267625,614303,340383,673153,408560,435631,487874,781714,210306,696969,652751,1034108,1048688,788155,382137,305449,931272,761720,570806,298037,459392,810973,177040,711175,878005,719211,1006400,347321,339265,9624,468504,900014,166119,439299,197740,315688,679140,1002097,482630,801829,975419,891564,1035457,589428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]