SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50605 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50605 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838809,571617,193060,107574,27143,1022341,369902,70206,646669,1021836,602526,945947,562122,415202,88556,1014659,742834,643990,762316,576219,725571,827790,346093,416584,406343,181081,207049,568280,359675,390312,597316,53605,598501,708182,128469,660530,324504,922811,556631,979249,983423,1012144,936889,1048000,227744,404079,558759,880936,1027824,884688,276415,796999,9499,629367,84851,477595,357605,909282,533569,485574) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50605 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50605 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]