SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103871 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103871 [ RunTime:0.002166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689665,658850,87910,500488,464387,848933,3239,705604,682150,393081,350487,936015,741488,197042,440779,573737,301873,275323,715646,719642,227424,407022,1032147,953592,64535,257380,499072,500905,398687,114902,541192,44579,682700,754115,434850,291548,758830,63800,781349,910300,131443,703039,1031424,920384,701719,1013032,247034,298398,119315,393329,762097,108459,541390,873303,301530,39190,358799,359810,133188,294843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]