SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328 [ RunTime:0.003259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181566,1004279,749778,836933,826889,666773,805262,130374,1027360,674158,586820,375052,3160,119922,241942,387600,165695,483294,474952,431756,816215,313490,306067,664634,375663,393669,525802,491875,642193,991685,982994,656121,432035,844140,940124,567353,493224,962529,760896,808877,906746,61108,116458,573016,219716,174254,306442,629838,170334,500171,662723,992259,651642,56287,1019849,142605,480319,281371,816888,58300) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]