SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44838 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44838 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (234113,399907,873830,803273,1018986,422587,11338,881190,36229,964189,881701,859104,997557,206905,553119,242522,856134,855990,439896,113576,1043851,497660,425307,706144,74251,1003423,984912,537654,810794,877256,953845,478982,431467,491575,755831,127166,408736,225455,952010,1032228,85052,572702,121256,945518,224208,81803,591182,339603,603576,736644,647031,634912,431589,755197,53192,633356,70147,778788,1024869,796443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]