SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52208 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52208 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (729501,17273,545165,152928,847881,837496,578699,409545,583093,1047891,913052,955689,569944,539391,130793,330018,631497,349671,266917,555061,309705,731658,424546,604160,540988,887875,881718,804318,801573,973730,427775,528174,62893,840041,457531,678563,270271,796584,727086,668308,366577,773567,602037,1022066,200640,839717,39419,703512,743518,485069,547980,765110,206363,24847,1048545,382741,400505,747330,708293,526038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]