SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54543 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54543 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563556,309577,377482,812177,752250,610660,850869,112816,808145,485804,647419,619432,117408,499067,494502,628490,635015,71277,587917,107920,79820,381920,293273,128853,936180,37199,479058,896365,172899,933424,549989,544535,938427,976288,117023,805533,678868,690268,77464,572271,532430,1040804,558248,235446,630126,403312,243526,313371,544885,529233,969965,424654,305684,112700,864899,635795,546463,455295,797289,55399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]