SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474073 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474073 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018522,391074,404589,350310,669196,707763,647739,421590,330510,626850,457894,270632,848383,801160,458763,48318,561135,996422,649130,178577,535671,782465,197434,811711,38346,153198,84329,369783,347196,181009,656894,155469,960804,258016,632957,189836,690585,460203,593690,326568,766665,306418,876549,744519,1040660,747259,402742,1048358,700199,155104,946301,669498,42209,1045297,758579,591157,33864,503006,640793,837487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000758s ]