SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4408 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4408 [ RunTime:0.003172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584913,344909,32180,63656,52655,736278,702392,1014691,189377,543042,3983,394578,602451,98149,420497,394299,135841,902681,402067,468798,472275,840070,148534,10008,419488,627728,639960,820747,608567,895674,149536,530780,953471,330907,628457,503465,379670,34201,220130,1000708,1029068,811735,817435,121754,619743,300092,296238,248841,776349,372093,206768,383949,191915,822171,540028,802814,953295,378895,441363,575955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000356s ]