SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007680 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007680 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441638,752876,487123,52345,709854,892766,981665,452878,623940,61132,330343,292410,453707,58453,289157,109836,98663,284456,1007024,730646,188219,429582,689026,4333,187053,127897,636135,791248,602251,271296,448466,387108,626097,583228,424426,803909,698183,278038,713263,831306,692230,588725,589284,854842,291850,16840,464850,531004,1010087,68589,174732,801496,324556,431184,555309,733338,979669,641242,989207,284459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002990s ]