SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568054 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568054 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496912,310029,233150,17979,723822,566307,601005,506603,195809,523670,482837,452453,979283,184713,631675,4284,391059,28872,842997,567588,444059,59271,374672,12898,241055,523888,180992,475793,279141,131189,821623,777655,928539,14721,35711,875840,678055,420695,335507,485381,90544,549503,979686,983177,586915,485391,599341,760808,766035,322751,667849,867204,1026783,344845,178228,947336,1027809,352872,214650,3071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]